drop table jms_dim.dim_tab_forfeit_rejected_config;

create table jms_dim.dim_tab_forfeit_rejected_config
 (
id varchar(200)                     comment '主键id'
,fee_name varchar(200)              comment  '奖罚名称'
,fee_menu varchar(200)              comment  '奖罚菜单'
,center_code varchar(200)           comment '机构编码'
,center_name varchar(200)           comment '机构秘境车'
,fee_number bigint                  comment  '剔除票数'
,fee_date date                      comment '费用计算时间'
,create_time date                   comment  '创建时间'
,create_by_name varchar(200)        comment  '创建人'
,create_by_code varchar(200)        comment  '创建人编码'
,update_time date                   comment  '更新时间'
,update_by_name varchar(200)        comment '更新人'
,update_by_code varchar(200)        comment  '更新人编码'
) engine=olap 
duplicate key(id)
comment "剔除票数配置表"
distributed by hash(`id`) buckets 1 
properties (
"replication_num" = "3",
"in_memory" = "false",
"storage_format" = "v2"
);
